{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["README","REG","RULES"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,26,10]]}
[]
[null,"Preferred Pharmacy Report"]
[]
[]
[]
[null,"Start Date","End Date"]
[null,"2019-01-20","2019-01-28"]
[]
[null,"This workbook will automatically minimise to the taskbar while compiling and maximise once finished"]
[]
[null,"NOTE:"]
[null,"This will only work if Vision is on DLM485 or above."]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection"]
[null,"Excel 2003 - Not supported"]
[]
[null,"Updated: 26/01/2019"]
[null,"Version: 1.0"]
[null,"Written by: bradley.sieve@visionhealth.co.uk"]
[]
[null,"Disclaimer"]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]

{"sheet":"REG","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Desc","Code",null,"Option Buttons",null,"Qtr End Dates"]
["ACTIVE PATIENTS","REG000",null,0,null,"Apr-Jun"]
["Applied","REG001",null,null,null,"Jul-Sep"]
["Permanent","REG002",null,null,null,"Oct-Dec"]
["Temporary Resident < 16 days","REG003",null,null,null,"Jan-Mar"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]

{"sheet":"RULES","index":2,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Preferred Pharmacy Report"]
[]
[]
[]
[null,"Search Criteria"]
[null,"Acute & Repeat Issued Medication"]
[null,"Drug Source = In Practice"]
[null,"Preferred Pharmacy is not empty"]
[null,"Prescribed within date range on README sheet"]
[null,"Registration Status = ALL"]
[null,"Input Operator - Selected on the staff sheet"]
[]
[null,"Sorted by"]
[null,"1. Pharmacy name"]
[null,"2. Script Date"]
[null,"3. Patient Name"]
[]
[null,"How to use this report:"]
[null,"Click the staff button on the README sheet to display a list of staff that have issued scripts"]
[null,"within the date range you have entered."]
[]
[null,"Enter a character (like X) in column A \"Select Users\" for each staff member you wish to "]
[null,"base the search on as the input operator"]
[]
[null,"Note: if there is only one staff member on the staff sheet it will automatically use them in"]
[null,"the search as the input operator"]
[null,"At least one staff member MUST be selected to run a search"]
[]
[null,"Once staff members have been selected, go back to the README sheet and click the "]
[null,"compile report button"]
[]
[null,"When the report has compiled it will create a \"DataTable\" sheet"]
[null,"This will show a count of all the scripts for each pharmacy"]
[null,"Double-click on a Count number to create a separate sheet of all the scripts for that pharmacy"]